/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : dev:3306
 Source Schema         : zx

 Target Server Type    : MySQL
 Target Server Version : 50732
 File Encoding         : 65001

 Date: 16/05/2022 12:48:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for contract
-- ----------------------------
DROP TABLE IF EXISTS `contract`;
CREATE TABLE `contract` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '合同名称',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `signatory` bigint(20) DEFAULT NULL COMMENT '签订人',
  `papers` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件路径',
  `papers_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '合同文件名',
  `house_id` bigint(20) DEFAULT NULL COMMENT '房屋id',
  `decoration_scheme_id` bigint(20) DEFAULT NULL COMMENT '装修方案id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='合同';

-- ----------------------------
-- Records of contract
-- ----------------------------
BEGIN;
INSERT INTO `contract` (`id`, `name`, `status`, `signatory`, `papers`, `papers_name`, `house_id`, `decoration_scheme_id`) VALUES (3, '12', 1, 23, '/download/bdf7442a-d183-449c-bb95-b19396c5a37f2021年2H绩效目标调整.xlsx', '2021年2H绩效目标调整.xlsx', NULL, NULL);
INSERT INTO `contract` (`id`, `name`, `status`, `signatory`, `papers`, `papers_name`, `house_id`, `decoration_scheme_id`) VALUES (4, '1221', 1, 30, '/download2/d3340567-6cc0-45bc-8eae-d74455b0697206_尚硅谷大数据技术之Spark性能调优与故障处理（1.1）.doc', '06_尚硅谷大数据技术之Spark性能调优与故障处理（1.1）.doc', 4, 2);
COMMIT;

-- ----------------------------
-- Table structure for decoration_scheme
-- ----------------------------
DROP TABLE IF EXISTS `decoration_scheme`;
CREATE TABLE `decoration_scheme` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scheme_name` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '方案名称',
  `renderings` text COLLATE utf8mb4_bin COMMENT '效果',
  `unitPrice` decimal(10,0) DEFAULT NULL COMMENT '平米单价',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='装修方案';

-- ----------------------------
-- Records of decoration_scheme
-- ----------------------------
BEGIN;
INSERT INTO `decoration_scheme` (`id`, `scheme_name`, `renderings`, `unitPrice`, `user_id`) VALUES (1, '123', NULL, 23, NULL);
INSERT INTO `decoration_scheme` (`id`, `scheme_name`, `renderings`, `unitPrice`, `user_id`) VALUES (2, '21', NULL, 123, NULL);
COMMIT;

-- ----------------------------
-- Table structure for decoration_scheme_picture
-- ----------------------------
DROP TABLE IF EXISTS `decoration_scheme_picture`;
CREATE TABLE `decoration_scheme_picture` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `src` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `decoration_scheme_id` bigint(20) DEFAULT NULL COMMENT '装修方案id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='装修方案图片';

-- ----------------------------
-- Records of decoration_scheme_picture
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for furnish_order
-- ----------------------------
DROP TABLE IF EXISTS `furnish_order`;
CREATE TABLE `furnish_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `decoration_scheme_id` bigint(20) DEFAULT NULL COMMENT '装修方案id',
  `order_unit_price` decimal(10,0) DEFAULT NULL COMMENT '订单单价',
  `square_meter` int(11) DEFAULT NULL COMMENT '平米数',
  `order_sum` decimal(10,0) DEFAULT NULL COMMENT '支付金额',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `order_number` varchar(155) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '订单号，随机生成',
  `status` int(11) DEFAULT NULL COMMENT '订单状态',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='装修订单';

-- ----------------------------
-- Records of furnish_order
-- ----------------------------
BEGIN;
INSERT INTO `furnish_order` (`id`, `decoration_scheme_id`, `order_unit_price`, `square_meter`, `order_sum`, `create_time`, `update_time`, `order_number`, `status`, `user_id`) VALUES (1, NULL, 123, 23, 2829, NULL, NULL, '70ba4759-23fb-4e21-9374-9351de4d50ea', 0, 30);
COMMIT;

-- ----------------------------
-- Table structure for house_information
-- ----------------------------
DROP TABLE IF EXISTS `house_information`;
CREATE TABLE `house_information` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `address` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '地址',
  `size` int(11) DEFAULT NULL COMMENT '大小',
  `introduction` text COLLATE utf8mb4_bin COMMENT '介绍',
  `phone` varchar(15) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系方式',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='房屋信息';

-- ----------------------------
-- Records of house_information
-- ----------------------------
BEGIN;
INSERT INTO `house_information` (`id`, `address`, `size`, `introduction`, `phone`, `user_id`) VALUES (1, '212', 123, '123', '', NULL);
INSERT INTO `house_information` (`id`, `address`, `size`, `introduction`, `phone`, `user_id`) VALUES (2, '13', 12, '132', '', NULL);
INSERT INTO `house_information` (`id`, `address`, `size`, `introduction`, `phone`, `user_id`) VALUES (3, '13', 23, '3213123', '15082384130', NULL);
INSERT INTO `house_information` (`id`, `address`, `size`, `introduction`, `phone`, `user_id`) VALUES (4, '123', 23, '23', '2332', 30);
COMMIT;

-- ----------------------------
-- Table structure for house_picture_information
-- ----------------------------
DROP TABLE IF EXISTS `house_picture_information`;
CREATE TABLE `house_picture_information` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `src` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片地址',
  `imageName` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片名',
  `house_information_id` bigint(20) DEFAULT NULL COMMENT '房屋信息Id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='房屋图片信息';

-- ----------------------------
-- Records of house_picture_information
-- ----------------------------
BEGIN;
INSERT INTO `house_picture_information` (`id`, `src`, `imageName`, `house_information_id`) VALUES (1, '/download2/a5d65807-44ed-420f-9002-fb7e55424fa91.png', '1.png', 1);
INSERT INTO `house_picture_information` (`id`, `src`, `imageName`, `house_information_id`) VALUES (2, '/download2/f4e0c10d-d1b0-4dd8-bcd3-253c747708a8阿松大.jpg', '阿松大.jpg', 2);
INSERT INTO `house_picture_information` (`id`, `src`, `imageName`, `house_information_id`) VALUES (3, '/download2/673950a1-7302-4452-b7cf-7017ed1d3cffR-C.jpg', 'R-C.jpg', 2);
INSERT INTO `house_picture_information` (`id`, `src`, `imageName`, `house_information_id`) VALUES (4, '/download2/59a67928-75e1-438a-947b-196ef26b806abg3.jpg', 'bg3.jpg', 2);
INSERT INTO `house_picture_information` (`id`, `src`, `imageName`, `house_information_id`) VALUES (5, '/download2/0898bfcd-8c8c-4c63-a621-a22d270d3637bg1.jpg', 'bg1.jpg', 2);
INSERT INTO `house_picture_information` (`id`, `src`, `imageName`, `house_information_id`) VALUES (6, '/download2/ab4f279e-3e8f-4a00-86a6-a5575c5fa709阿松大.jpg', '阿松大.jpg', 2);
INSERT INTO `house_picture_information` (`id`, `src`, `imageName`, `house_information_id`) VALUES (7, '/download2/1745415f-3e54-4b39-af33-7e0131f06d6eparseTree.png', 'parseTree.png', 3);
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (1, '数据管理', -1, '', '2022-03-01 22:18:43', '2022-03-01 22:18:45');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (2, '用户管理', 1, '/index/user', NULL, NULL);
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (3, '菜单管理', 1, '/index/menu', NULL, NULL);
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (17, '角色管理', 1, '/index/role', '2022-03-12 16:36:12', '2022-03-12 16:46:05');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (18, '合同管理', 1, '/index/contract', '2022-04-09 16:29:20', '2022-04-12 00:29:33');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (19, '房屋信息管理', 1, '/index/houseInformation', '2022-04-12 07:47:02', '2022-04-12 07:47:02');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (20, '装修方案管理', 1, '/index/decorationScheme', '2022-04-16 16:01:43', '2022-04-16 16:01:43');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (21, '装修中心', -1, NULL, NULL, NULL);
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (22, '设计中心', -1, NULL, NULL, NULL);
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (23, '我的合同', 21, '/index/myContract', '2022-05-16 03:06:10', '2022-05-16 03:06:10');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (24, '信息登记', 21, '/index/houseInformation/add', '2022-05-16 03:10:43', '2022-05-16 03:34:38');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (25, '装修方案挑选', 21, '/index/decorationScheme/choose', '2022-05-16 03:14:34', '2022-05-16 03:14:34');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (26, '我的订单', 21, '/index/furnishOrder', '2022-05-16 03:15:59', '2022-05-16 03:15:59');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (27, '装修方案设计', 22, '/index/decorationScheme/add', '2022-05-16 03:17:28', '2022-05-16 03:17:28');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (28, '房屋资源查看', 22, '/index/houseInformation/list', '2022-05-16 03:19:49', '2022-05-16 08:24:46');
COMMIT;

-- ----------------------------
-- Table structure for menu_role
-- ----------------------------
DROP TABLE IF EXISTS `menu_role`;
CREATE TABLE `menu_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `menu_id` bigint(20) DEFAULT NULL,
  `role_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of menu_role
-- ----------------------------
BEGIN;
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (46, 2, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (47, 2, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (52, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (53, 6, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (54, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (55, 7, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (56, 8, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (57, 8, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (60, 17, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (61, 17, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (62, 10, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (63, 10, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (64, 9, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (65, 9, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (67, 2, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (70, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (71, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (72, 8, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (73, 9, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (74, 10, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (75, 17, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (77, 2, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (80, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (81, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (82, 8, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (83, 9, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (84, 10, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (85, 17, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (87, 2, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (90, 6, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (91, 7, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (92, 8, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (93, 9, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (94, 10, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (95, 17, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (96, 1, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (97, 2, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (100, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (101, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (102, 8, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (103, 9, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (104, 10, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (105, 17, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (106, 18, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (107, 19, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (110, 1, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (111, 2, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (113, 17, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (114, 18, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (115, 1, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (116, 2, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (117, 3, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (118, 17, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (119, 18, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (120, 19, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (121, 20, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (122, 21, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (123, 21, 4);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (124, 22, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (125, 22, 4);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (126, 23, 4);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (127, 24, 4);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (128, 25, 4);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (129, 26, 4);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (130, 27, 5);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (131, 28, 5);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `role_key` varchar(10) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `teacher_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `name`, `role_key`, `update_time`, `create_time`, `teacher_id`) VALUES (3, '管理员', NULL, '2022-03-12 16:57:51', '2022-03-12 16:57:51', NULL);
INSERT INTO `role` (`id`, `name`, `role_key`, `update_time`, `create_time`, `teacher_id`) VALUES (4, '普通用户', NULL, '2022-04-09 16:00:45', '2022-04-09 16:00:45', NULL);
INSERT INTO `role` (`id`, `name`, `role_key`, `update_time`, `create_time`, `teacher_id`) VALUES (5, '设计师', NULL, '2022-05-16 03:17:55', '2022-05-16 03:17:55', NULL);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(40) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `nickname` varchar(40) DEFAULT NULL,
  `phone_number` varchar(19) DEFAULT NULL,
  `mail` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `create_time`, `update_time`, `nickname`, `phone_number`, `mail`) VALUES (30, '2', '$2a$10$k2IfqTIz1CEnSX2J0OKHWOgllw/K3wpAOeLUBPBgWg4ap8EKGMpZS', '2022-03-06 01:42:46', '2022-04-16 02:01:41', 'test', '12341243', '1432');
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `role_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (41, 30, 3);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (42, 30, 4);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (43, 30, 5);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
